SELECT r.*
FROM
    results_barrel_races AS r
     where r.time!=0.000 AND ((`date` = ?)) 
group by r.time, r.rider
ORDER BY
    r.time ASC<BR><BR>Unknown column 'date' in 'where clause'